SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048830 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048830 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510615,949430,520935,462815,602137,809616,202821,103050,1027156,711158,34347,807247,659722,418445,610072,231683,313337,160697,981256,573626,417980,783704,155416,711090,557949,969945,468630,603103,130822,786492,396822,959314,316413,216099,332862,707370,958362,426810,29525,434333,188109,894354,247289,297398,727125,964001,320317,1028717,983201,182974,87004,308142,851295,477579,633530,173650,1022025,438232,808022,345075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]