SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033407 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033407 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204940,269854,481559,332998,569971,197346,623364,209120,938405,181572,737218,998874,928371,30611,893620,890412,1031882,436179,369477,815143,506562,1043379,982347,929754,421338,556343,233470,737180,388254,630559,132664,126269,1000598,251305,362822,163244,884699,36910,446714,1026689,606184,336274,563255,378164,705364,635581,672501,149172,267917,994062,559432,102974,163256,716497,879412,339391,755440,891782,151803,352865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]