SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982309 LIMIT 1 [ RunTime:0.000863s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982309 [ RunTime:0.004085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381290,286278,443062,310409,300917,598674,582459,780396,420305,510013,1021777,981651,805797,780449,559641,970501,38364,438799,931863,483420,481976,783822,259875,148002,421762,63620,725718,203948,484932,83029,205284,1006222,162734,775458,134195,489397,581018,389189,411669,831491,45378,806356,735107,201698,62927,429217,290798,1011492,778344,877358,723250,298034,133202,535849,422918,640993,932791,445746,713307,43096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]