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` = 1000580 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000580 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60440,608132,169037,574232,781284,1038076,193839,957963,571355,628985,484996,653170,100445,500421,28,84452,645715,336394,49772,515302,497752,309204,725595,401414,869552,618638,435330,65736,597056,397761,611321,701669,585308,658824,824187,338850,140155,384013,1038920,459037,185676,675954,703712,99042,345837,990832,87869,939376,337471,574507,279193,492392,680684,61470,255351,625689,784142,438092,203913,632360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]