SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046651 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046651 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64357,488597,451305,411173,873197,954901,266744,231682,915214,346625,555328,19899,233230,425543,567184,681754,608748,926004,873905,805696,152913,770501,154572,548689,587624,122142,831866,992390,354530,545317,159459,547565,941328,292290,930480,86289,261742,97517,242378,676750,614555,166133,634176,741492,639739,160750,883965,167930,784028,208235,707081,401464,170268,302230,402092,143312,647504,123539,336100,952601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]