SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554013 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554013 [ RunTime:0.002556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49899,122582,549644,833512,508425,831082,316475,780250,347550,862632,219791,658716,754003,619571,880161,11421,582603,988206,267642,788921,157086,588693,488394,475782,948495,753200,405719,1018458,152994,970245,6024,298221,701948,197179,889807,223825,837107,611414,536630,30655,823578,197642,936193,774312,184219,325970,831644,613646,428277,426757,239473,540005,107007,565193,830626,18354,714213,16653,930912,1046388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]