SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142683 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142683 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448836,484492,485987,791914,638803,334807,825592,844422,113365,219886,771749,787599,607365,1020171,364239,560193,491663,182861,621781,282486,467867,1024623,650452,708432,484290,265732,409725,923265,666902,241062,516185,315822,352566,1018403,923433,541490,552617,834117,210813,638004,58176,947165,589597,100493,356296,963628,268105,675805,819963,973855,912393,850257,778350,534207,667457,341696,1002046,742694,98585,337754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]