SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 993413 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 993413 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508228,261721,1033763,525833,580595,356199,23359,698807,94554,327334,889449,122002,114458,982545,329522,996095,919818,659674,199483,269876,542113,731453,22245,981577,805730,516083,241096,602129,822095,146942,1034598,927045,748689,509002,190739,655275,231631,943393,433009,762742,910587,1027116,873509,879963,1034629,710837,921195,855409,137160,205502,326215,354329,876332,339860,75870,584208,191114,5958,805304,887023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 993413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 993413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]