SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001201 LIMIT 1 [ RunTime:0.000650s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001201 [ RunTime:0.002847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505302,821439,586141,898370,412132,472097,113171,967097,772322,365775,455540,514987,578662,1039545,481442,292919,879201,598074,460444,1002562,1010407,432954,727804,524308,30895,745174,659498,543525,728993,132742,659188,492167,721568,404060,146182,737770,829654,830296,387309,362325,647007,389315,964551,679461,758752,41251,983339,706497,1005484,168608,80860,53085,557915,693392,208716,968350,130307,100075,502036,988654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]