SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041796 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041796 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451076,300744,104372,787393,590561,230014,902190,37242,723551,389111,48062,903635,952133,668584,490940,769416,336137,199013,366933,460810,851609,961629,126327,371307,270918,569528,558663,177215,437264,991592,736158,595000,777457,976035,725737,448420,458945,235350,802713,453766,237430,430162,74377,444406,553476,749437,1029666,982686,928374,158282,473244,97520,612798,302005,184422,30885,658136,208144,28237,233296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000978s ]