SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025516 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025516 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352024,221947,904727,385820,671248,824934,49927,32718,435268,413982,1018694,245310,431874,871398,696322,995639,251118,931661,138967,118330,82317,653841,862591,594669,575474,413685,853524,127659,117292,391941,586368,369806,592319,33528,223106,585416,643891,95943,828602,271880,523798,950859,201718,101844,212735,720595,884273,114383,740404,969934,781409,849347,14585,99459,1037759,393117,33664,951143,845405,224824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]