SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53967 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53967 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881770,867345,612052,809944,735232,881681,723205,55008,896786,87364,165794,1010135,145736,1043813,433793,202929,331428,469757,441396,887196,201784,29711,400632,888410,595060,546839,459454,842520,821517,660047,702801,536015,949727,177056,157393,36994,769992,887084,1023369,329640,602022,292380,78369,137278,45864,961839,390748,545033,663259,729452,31671,167933,961668,885875,594107,354068,95709,558996,824892,570578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001634s ]