SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040113 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040113 [ RunTime:0.020973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635012,291011,819616,696230,452630,473158,1040848,51775,573905,845269,70413,519727,68503,953632,494592,348580,371347,624272,178373,172387,281078,452845,1009508,1047474,406020,279773,372865,836758,824943,821555,115344,284914,160432,776837,1028883,538366,610409,234232,1004991,243697,848958,61560,729150,253293,1010721,148935,60433,129166,72670,989849,486774,295077,876859,1033981,47677,536807,550109,591012,878581,400561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]