SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506051 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506051 [ RunTime:0.005434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759063,349604,923741,366057,720489,1035811,243106,777157,680045,37430,365061,75494,555709,27421,586832,988791,183286,1029726,84846,528980,181264,1016973,679364,730332,301577,766729,139730,117322,187385,824388,589610,558858,769051,69539,215979,237202,65719,191582,653131,166699,474693,303956,110020,454585,417713,151075,157129,927029,1005628,969106,503241,894574,370179,835943,231979,31672,930446,811600,902570,894602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]