SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417224 LIMIT 1 [ RunTime:0.001301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417224 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991672,196,263925,650458,190469,78812,933558,372224,824782,460948,228870,172398,567288,182476,861905,751334,239139,503453,1028504,213108,744309,514180,146912,988441,431700,28753,703925,487648,823181,841068,776429,127437,459262,148525,698295,489944,716952,23485,115372,234630,256184,601436,959547,672564,5754,764577,1018789,1001266,490550,958389,680373,352623,534924,536382,207845,50555,290540,216677,380458,418632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]