SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473991 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473991 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590040,1001906,626083,88352,97824,181521,733242,205462,693427,383951,991578,147270,811838,970207,898622,393257,220216,937983,153955,992780,18016,169917,365549,190411,951349,650852,323871,569706,546597,245385,916546,187908,359605,140839,257672,847865,621092,436953,886550,331852,871058,553562,577899,84987,443977,1018475,845788,738040,235913,1031733,543448,742240,387982,852538,87965,30429,860823,491506,439282,324556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]