SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513200 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513200 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32024,440576,1039394,20004,1009973,186719,124362,121238,227334,937061,345156,987387,26721,51538,443457,1025703,595483,727050,276445,1004787,506473,416782,636066,780852,650336,625581,1015902,957873,84247,91043,203175,945934,3141,978163,672429,724623,605960,550276,460220,465587,258622,199721,418529,966599,795084,292728,720297,206692,605744,177473,588716,83220,536532,1034829,837138,562411,192217,184669,500887,680849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]