SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391704 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391704 [ RunTime:0.003136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820198,25354,654559,836147,250231,820434,867642,474358,674933,91259,445710,488946,572640,753374,581806,49446,607083,275426,931052,978157,341592,838135,276789,86622,101511,180839,597596,753317,660235,1009205,441676,687675,694718,447136,37743,928500,822951,561221,99445,325838,627587,686593,82344,623109,876994,774096,475231,220289,443776,432616,166374,264925,985587,524701,101283,696821,225230,489461,815777,46404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003455s ]