SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022216 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022216 [ RunTime:0.004224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894321,103383,599680,367238,846188,65340,758579,293691,826048,173631,314953,552400,704616,864492,967827,141259,581292,703268,984867,685101,995598,584296,445168,358688,664500,829237,630419,980186,49541,151389,1012445,109782,1009489,731282,992659,604817,35354,627996,462727,504956,799479,339566,743346,320855,432341,362731,418358,388443,968654,15896,508680,492158,857437,147931,704942,519655,800192,669508,542444,113677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]