SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200802 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200802 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531757,620276,497943,90355,997977,173270,177497,342551,554118,780077,65408,522414,328179,779540,632816,303512,106150,463678,273076,915782,221560,624339,681673,553835,472894,838377,362445,78869,592257,169388,886095,58524,271800,812684,274289,980594,729920,680950,970763,30712,896252,748670,1036667,869393,5,977256,129810,228832,1012225,789171,242572,576776,30737,985796,194392,832227,44826,34782,607949,33062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]