SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038101 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038101 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421898,331873,177814,382943,86533,359485,534682,851118,214391,75780,581368,943716,234589,566198,671150,1037301,110824,398603,250400,655750,944629,751874,160250,1007127,852393,321073,610865,995717,760659,943392,883243,818055,798986,205474,401837,87977,228717,834617,599399,685255,14165,358983,6679,437050,902873,913143,845076,481211,309257,601507,502953,948092,855624,533234,605059,1035396,563637,41428,663208,715377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]