SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002647s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455547 LIMIT 1 [ RunTime:0.000605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455547 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036959,1015079,387286,618736,82125,255767,64613,154802,315479,277180,247636,913110,104902,367740,382016,252961,247632,915145,559632,424043,259320,331377,1036968,282214,791665,508363,996612,511632,403366,401731,332678,287711,807987,715587,843592,62826,78111,832134,72770,1035685,517824,858302,263216,152062,591393,673575,150344,337271,797676,428835,526050,841551,264965,374185,891272,775827,908212,64398,654498,199546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]