SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017696 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017696 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83218,936655,201196,778706,841031,407011,783671,707945,320078,651480,312200,877520,446772,395604,175128,957123,1027694,171782,727266,283251,553124,923361,941710,722086,105280,448683,300610,76457,587667,901002,976435,360804,861033,311988,198457,437340,219812,202289,107203,318722,888438,1017826,429269,989871,759211,568199,701208,5893,362229,139089,388045,718062,479555,816094,802179,812315,706204,269578,368942,170072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]