SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314583 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314583 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648347,547355,1008084,767626,457558,143472,864543,645288,804458,310144,418710,536779,936961,432342,481414,470149,467458,735612,799120,926356,662360,554423,541918,680139,868111,172434,154917,9192,425431,443754,836910,609515,470876,576059,652144,974673,868087,101739,949038,988732,1010806,132652,168025,674174,518141,297785,774789,725381,1038921,3519,891702,253984,469074,481391,595066,711357,868469,421542,565062,704103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]