SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435800 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435800 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4254,924103,561046,420734,269974,682552,351425,540601,146014,196495,961707,26147,667531,321322,145670,325881,577053,158495,94625,470188,276035,669542,369791,537271,55490,560385,647813,189144,587759,276118,863295,486856,316026,246730,921048,304840,861627,690344,488691,98709,203550,488919,773794,297276,223551,440747,237796,611306,591933,129111,374795,272837,314284,1036932,167545,446467,148776,462082,566783,233385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]