SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531326 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531326 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751465,689443,600057,346170,446911,767204,176301,509813,870322,785221,856402,1043528,192660,56674,508809,838456,137041,587650,452984,362913,363853,296558,142467,1041359,482651,36219,693953,687133,108510,269354,141822,972351,372889,806580,456806,495849,1037709,797619,832903,620100,363408,882858,793875,736928,887270,723765,295127,101031,619657,702103,792512,693344,67455,784849,51890,61836,321552,402367,1018817,731357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]