SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018972 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018972 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585989,72289,60478,670418,552092,173579,24143,390582,706174,523623,507620,451,890991,229953,712517,151981,93043,697927,418841,151962,821696,859622,4953,429521,420924,610250,1025646,794413,177934,3781,705192,1021518,1044023,708726,497676,771777,374161,1038268,836675,165253,22875,162484,452923,824824,143016,413840,294740,1020174,97075,685901,476254,898456,537886,621790,622776,616539,616914,271728,983741,432281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]