SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548563 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548563 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555776,515713,23449,571427,392941,299763,102797,160941,458010,199388,195757,604241,610660,177215,43733,615793,678602,175459,375855,319002,856099,112467,1046327,332673,828703,50121,988889,17568,866594,351944,82294,527644,494987,588511,582125,187133,179135,777497,849822,130712,644985,615651,525848,644473,193579,889307,187097,669919,671619,700134,767011,724554,48719,554901,812394,854916,501614,637274,172403,244094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]