SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 63581 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 63581 [ RunTime:0.003900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320308,880196,247084,454043,637036,247148,1012850,674584,561847,1010621,791953,70535,47213,495882,677533,171358,235141,781330,714084,601504,1030199,1008811,984508,179570,359511,392634,295575,1009476,300484,320837,1013547,467816,1005585,34466,353988,519413,645009,210815,435797,760290,1022134,705143,421103,272531,136302,801174,791602,524734,367905,641981,655100,109788,183055,535177,639655,376150,145799,413565,210628,97280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 63581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 63581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000894s ]