SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040016 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040016 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884632,192873,794433,118281,56731,50749,215673,814152,150246,714667,984847,352353,374963,365509,984067,383656,702663,389671,20760,2877,196032,576400,374439,843826,777678,628573,225641,610455,16545,855933,938104,247745,442213,232430,644519,1044345,8387,414534,120969,239170,45334,974567,287755,334947,461361,637013,430003,444874,361714,47591,7714,381596,13611,775407,985609,697131,349936,218334,407337,934541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003618s ]