SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10403 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10403 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002682,590958,1030743,445770,140711,761192,100782,262408,608004,726268,374900,618534,983602,410721,671530,949694,508158,1006309,441369,858111,920148,399755,816964,897779,213843,695713,542903,718101,207862,532507,152751,349511,14556,277434,145487,991675,289447,758405,271639,833412,128715,165221,473788,677487,806468,448184,458545,620129,823879,942701,659771,352454,639359,287939,566696,219696,158138,417609,837370,910042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]