SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562767 LIMIT 1 [ RunTime:0.000276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562767 [ RunTime:0.003033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022246,423315,790576,540533,126511,1047314,408019,944753,1031621,130217,131155,58649,897008,812424,543611,817883,161838,576846,905328,666695,463573,1029485,439654,530328,198680,682878,809375,995103,721654,841279,705762,842391,466891,178601,48933,9725,297294,824413,953614,683643,959638,1021800,470948,889873,419602,827698,177448,543282,57228,358862,415536,128209,955936,814583,918447,276943,282873,980568,924785,181066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]