SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395853 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395853 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523380,345646,286998,248652,790148,374867,1020901,648041,914951,683320,604146,567015,713092,632512,902797,687604,194582,938199,389236,45964,507316,1025960,211972,51445,590733,653880,459963,425831,4432,728267,911232,1022618,414960,797526,269832,381174,198077,978992,580005,32566,787883,451983,41833,561173,93015,308925,338354,291482,391028,524615,371695,121055,971531,929664,240124,478140,211732,347735,709720,235938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]