SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455557 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455557 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973176,814491,655443,114413,165724,532376,382053,494738,483574,477484,872618,403021,1031400,384460,626925,930393,490157,927991,572070,281885,766245,383374,603823,369307,830602,280860,444017,630376,229687,973382,385400,43827,359437,447339,888340,848615,740300,381440,505415,511796,394319,598602,363579,621958,803962,554898,790260,547411,819901,679838,339731,186115,564165,692651,206531,549795,971440,827590,180435,1003756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455557 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455557 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]