SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034160 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034160 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673669,375029,896810,335713,589562,58336,389564,1024387,854071,122487,899589,155465,871998,726905,191139,869489,585334,181680,877892,487065,455725,1036334,839702,154503,955845,524247,619408,506587,515499,695844,476673,411945,698976,310457,925451,398039,165957,66639,802528,240716,1017194,653367,670539,795490,1009081,1012304,396221,411299,501850,665901,370493,111796,1025501,148624,538919,1045808,113158,650962,61927,812959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]