SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510781 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510781 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239367,451482,414207,965985,367444,456608,554762,648904,194466,314595,5007,359635,559786,908518,699796,608315,1001737,647419,549820,580983,191200,471578,880470,611484,1000678,746128,917149,215321,181313,228157,411664,240597,744667,599608,745023,918110,75837,513925,766866,641704,116323,831817,530293,16270,815778,428027,800852,881072,913511,242626,693919,445883,869033,731164,708890,118873,840055,311219,1030477,224085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]