SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046918 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046918 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473524,513038,513194,741813,5012,418735,274501,42592,532747,244704,216172,76891,147561,183240,100331,791425,44453,319044,1036338,884535,481738,791749,1039853,129458,395843,553210,629836,630404,1018543,533056,548363,150353,771302,853613,686018,376897,960723,999209,9304,329392,423199,978600,442229,662934,52148,69319,199274,286856,96475,948956,772634,550728,865241,779730,253066,244575,262352,476478,166922,102304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]