SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043971 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043971 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317260,1046625,705294,33839,473024,111574,1045133,1036121,510523,867708,626167,203030,1035374,283370,1024716,919194,649966,681846,133912,642282,346976,415609,37770,381805,336644,717581,838406,168948,923207,356358,754943,654919,920589,969905,660527,233821,442945,51897,207357,809794,70908,407441,10684,33266,487515,1002464,252002,932548,261365,240619,665118,652117,165548,543046,35608,692006,168073,153172,116813,224147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]