SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503529 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503529 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696933,557498,64503,692135,883536,205745,428868,122884,668566,188196,547588,693731,156426,225728,390931,573823,816749,376062,907481,183669,723233,283365,802695,633719,463861,343299,976998,675729,567887,748122,111583,772651,805086,49692,981060,46106,960002,101324,845170,293837,243432,1017699,146963,865723,347602,878726,1020568,1034633,294026,772291,366388,943065,1027396,346474,240701,580620,921209,478042,482465,531421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]