SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455313 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455313 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641131,707234,70005,922695,545029,483402,141176,572439,958469,774111,583048,483695,654617,236195,505381,955529,816622,727564,855213,765120,102736,68357,611946,346541,250367,249609,726964,103095,192340,146415,1022036,117292,591168,145918,52617,405216,631708,602666,610095,360678,376055,306573,346519,494391,685762,978949,853071,919772,266673,946361,649211,596582,133047,229616,1029808,950422,534111,918080,514372,207230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]