SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464309 LIMIT 1 [ RunTime:0.000688s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464309 [ RunTime:0.004051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048581,802983,675156,992337,326906,1008438,599407,789789,723834,437013,154558,520735,1016039,471008,817448,629694,234852,355263,482055,445690,756312,1024402,998395,14536,807298,994561,736647,648625,835648,64692,752664,435695,500488,378133,907634,792520,523956,92887,327963,389766,12433,645045,578327,687215,570702,988628,1038428,118104,449161,441597,633556,196029,912438,615768,1037280,629645,273316,1047654,663047,868479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]