SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556309 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556309 [ RunTime:0.003935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113653,123788,24470,883034,828008,959918,211061,242376,160223,271963,78261,711645,223307,626441,236961,17357,302543,233638,407544,389485,499569,745333,822201,846483,109490,48788,613773,408650,749852,521257,244246,526515,140219,349781,90533,1030202,163903,720794,886991,83770,862218,96126,503859,406722,210668,279698,78856,713365,664106,47782,74992,586189,261359,331926,378110,524159,141916,776036,289405,930059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]