SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110463 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110463 [ RunTime:0.003115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005674,75113,607340,83836,746881,915148,583930,90077,477652,885153,895178,703114,894995,309122,164963,741749,828604,251633,999470,537258,797648,275912,766007,969915,14038,177081,669732,751490,447542,166257,888936,321690,440090,768471,564849,675990,989548,431216,789353,118389,989642,176188,499966,10091,85670,128436,547479,378172,428436,799566,630284,387160,134726,839602,7803,809283,370550,822528,150748,912683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000902s ]