SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 935113 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 935113 [ RunTime:0.003166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566690,814334,147859,839423,993190,995054,1000695,276361,980045,801529,779030,611075,941069,474601,303070,525335,185865,742546,839070,57838,185659,164990,110317,5519,472313,920660,639819,571792,87716,901278,650104,14170,788599,1025571,901758,808100,318999,422499,127777,66236,21268,184540,468339,754647,823599,108954,414391,719487,437887,990503,194560,660889,433331,660927,160760,737992,1013076,508399,1024452,1040753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 935113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 935113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]