SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 628312 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 628312 [ RunTime:0.005120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005568,611178,717238,774543,1020186,629253,406119,583637,28802,874442,762303,118550,405926,314225,157679,1015330,472557,321515,835936,13267,897349,729824,326163,81533,318902,741131,59706,335936,873788,777570,301005,1004199,900942,983023,969856,962764,277488,548234,320424,462715,377855,89381,479484,575667,957722,332755,384776,240039,980843,933164,577950,557466,194601,884773,47034,1030423,827644,787897,396367,98681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 628312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 628312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]