SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462271 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462271 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26197,584683,253290,1021583,642553,289577,579129,371987,863098,712015,736669,412008,533451,599147,1000974,589450,163865,255324,25094,816968,295781,895436,836586,827506,81751,610226,962376,694235,573220,506595,749793,798174,927041,140953,519721,400983,459796,97216,256448,226819,189222,973858,266502,707202,386779,167797,426142,783977,455090,803253,680090,358417,846865,24802,980721,1011809,163757,41377,139007,428237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]