SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387048 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387048 [ RunTime:0.002949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783586,798740,1002213,935609,508568,808017,1031432,852610,810044,202919,321623,384518,98930,953867,1009089,601750,390650,776821,670982,26640,734095,587881,597973,381787,9585,91029,621287,934984,29177,664983,1001038,152110,394623,315434,636699,459817,825566,144506,257629,450222,963592,1028848,670103,724013,831937,603317,909684,487220,877538,1018646,285747,801229,154415,471184,496826,725962,306217,654143,488332,749762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000921s ]