SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014378 LIMIT 1 [ RunTime:0.002495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014378 [ RunTime:0.003936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001346,68925,787151,750566,78457,576384,892557,151542,187236,891167,505894,970798,1026217,174758,1017617,522088,1015829,739411,230265,3866,114983,605777,872614,331450,511138,930289,870520,970245,685323,57599,517418,667683,495671,450702,468097,88004,977034,203031,48671,248934,753169,925758,279120,809511,570501,202313,783990,742325,701464,27038,403351,380455,259316,63117,870364,19656,233554,592962,952000,482775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]