SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261382 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261382 [ RunTime:0.003440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010915,405861,941197,379918,933330,565631,289657,344058,313010,599227,819948,61419,177215,262851,726722,168405,426311,718516,354237,131662,584983,112190,112770,406100,195306,577251,1001467,602931,568553,252577,490086,35415,63149,674688,301538,274198,766865,816545,1039593,972400,226168,393106,1017485,54344,729450,549236,769820,638971,88225,467494,493183,872164,62657,626824,42462,616338,84745,685787,431629,686159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]