SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545697 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545697 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236560,571714,453846,412500,478826,572284,187798,181457,778966,336792,444918,1007176,504877,257474,8958,251541,790902,675420,772111,581665,550586,600697,439628,772844,83191,477676,150599,712091,984471,702105,395471,263445,414428,150841,58622,621181,674667,127649,56022,896264,627422,798986,457151,20178,560071,848463,238220,738584,658927,852510,693827,969094,494249,691558,908729,181446,346671,145275,632819,504043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]