SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333310 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333310 [ RunTime:0.006350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141397,26300,540199,680659,64779,114727,298346,467602,40727,187065,466950,44143,981026,1033552,694064,143408,442182,247290,50053,110035,68068,723983,514963,651122,576517,698534,1009601,685640,502240,581894,256422,762560,1018074,198082,1027637,507968,383804,434721,752404,908437,438209,935549,190855,881715,28303,38823,1009637,738847,867376,996595,430956,1030932,245644,104891,781187,363324,534696,609051,20419,81228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]