SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106671 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106671 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642871,535565,218390,667029,376458,350953,35040,701237,134267,1040063,559219,1000325,245841,351786,138466,521327,1005893,486933,448182,272840,963276,224839,532971,723671,531307,188627,877467,350474,294441,784177,603688,773283,775135,84415,943272,1024367,551664,34325,227553,564975,882172,830973,497715,843092,211033,617178,56570,360703,806451,103563,253305,285053,959302,762264,439797,654101,528325,353524,456988,154241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]