SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492671 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492671 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409112,1037810,544246,1007615,77328,364117,599180,655586,855026,650402,552665,424846,73382,895616,313836,779076,897145,14609,164699,296247,718491,625218,213371,515356,747194,566944,400701,50808,600568,845740,490895,161654,138553,599394,924353,190868,127799,294103,198725,706343,127401,871869,1033540,1035320,303426,435951,259779,230054,383247,790969,319348,90330,306983,742110,206146,854083,651011,316257,726691,934061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002027s ]