SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317263 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317263 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026655,244884,826325,566907,997161,436580,14476,822441,109895,1002988,243170,710950,273575,1004861,55362,962848,289924,206144,445507,286832,305592,838840,922388,206002,861462,848617,1025502,800210,12438,394741,581303,833594,685411,142152,143394,1043228,889428,204943,395745,447021,99639,21,1032603,102063,70695,558156,696680,224835,525072,625993,60248,419385,572335,922114,80951,152378,403214,155552,928449,540578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]