SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416988 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416988 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981773,559342,665391,675822,749876,634614,668519,942864,755898,40383,528977,1008243,533614,187422,207770,75512,767255,632524,567313,361471,330952,82018,474850,1040042,314490,1019144,61825,611760,107672,830201,117672,363006,632831,437371,34742,1019263,177689,635201,407030,1047019,672557,69251,604902,21029,63916,181451,575197,918279,230402,554787,626761,454786,317910,316164,144414,388465,830715,787807,573150,470968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003915s ]