SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008535 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008535 [ RunTime:0.004580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269621,204318,64065,1047815,34464,948986,26744,66813,447100,470404,34914,44295,1047636,436358,778525,697118,751173,554264,546295,432954,958926,739374,741667,378930,224113,248062,240725,592302,784859,654273,258966,310778,1030160,558340,983797,466813,216411,833096,900403,180855,35003,421020,425650,233114,739974,457180,141055,577835,29193,926578,676935,1032660,85892,755536,914723,799855,866276,435103,1005075,247681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001571s ]