SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502846 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502846 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704304,996406,783610,583578,817675,991394,684339,430370,293280,642199,924673,147653,443858,106968,380045,487177,169127,719958,613572,579589,753773,933374,440415,324040,831290,1046088,377183,668469,64759,230289,559843,172524,933813,822278,660772,270162,1031827,900042,287633,703985,440610,764046,805610,389474,775693,178958,407585,151901,133038,935227,557128,338735,241660,993761,245678,1001787,631601,245727,535784,993200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]