SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002842 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002842 [ RunTime:0.001409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374170,147532,607493,967376,768102,1002764,179303,576292,51723,614943,501150,133630,996406,32801,875794,964974,1041381,1013205,129975,745854,8069,1023101,108235,814244,470541,700297,62176,479408,598846,60451,737281,206486,804669,116044,673210,491369,519814,612120,1038620,199603,973821,591412,43894,769379,96111,252123,8131,212440,158525,31059,887113,1027371,517309,15156,249024,663804,265671,1014543,95707,169861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003197s ]