SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648818 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648818 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001454,583604,599068,505149,431872,842475,467057,886883,699918,461720,97845,647963,118252,217572,588140,893774,50415,41861,312813,147691,653755,886117,686549,286360,445722,998896,869849,763340,378134,476076,91432,388359,81478,463352,876899,650259,397375,6751,711101,850830,213351,158986,841253,1042086,185156,834782,605962,14754,984381,504999,132387,769884,1037477,351229,460577,381597,703687,544728,23374,703780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]