SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154380 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154380 [ RunTime:0.003078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998715,287013,76982,134378,630595,237875,528228,542171,831050,471180,1010455,529791,23276,327006,63687,85129,352679,514372,213559,468123,818613,987133,586945,328480,205406,513753,774786,981360,1001107,90189,162485,33954,486413,605925,779933,197484,584897,738771,462009,317165,993367,627986,915363,695416,763781,304005,107402,449074,837302,856493,399514,558622,380210,856630,51071,892582,998837,626791,761342,166353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]