SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592570 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592570 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404444,551837,416417,470562,674895,1036147,416995,880124,596004,221730,499946,1012747,1028605,694225,771224,228425,819421,305857,783542,68545,250068,727595,354413,49825,372938,563835,981245,142329,613504,36023,669733,116135,130434,245685,63116,973995,603837,726104,994449,590493,638137,125562,94854,608792,877292,68102,933907,254440,909590,388435,169095,91320,894847,822992,280852,238056,289313,992337,44457,851593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]