SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010567 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010567 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103693,1035257,456408,799792,528646,332106,835570,22823,218913,878153,853041,157371,553610,953327,91631,340397,1028897,470968,133377,21325,137249,226442,612458,304186,510607,811375,124959,924021,190438,745071,87849,401774,845705,1023925,1016716,1048632,93526,258731,78774,628891,545569,165865,683774,398986,59259,1046496,365741,929183,378472,698495,495404,405951,698282,812961,94169,322904,1047497,420491,897121,1016953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]