SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416202 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416202 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229144,275046,478728,30195,616520,190435,348559,136589,103034,39146,707763,199161,497440,815401,467484,835735,53676,94753,79045,347008,323499,206871,393854,152994,21348,10972,479764,974821,483864,450372,117299,568657,642130,927435,1036321,379728,218910,760200,19066,46088,8250,625956,506889,620473,983182,405605,866508,548510,646189,614252,926348,590177,335014,23239,574576,1022944,615445,1029371,898707,114818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001503s ]