SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039454 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039454 [ RunTime:0.002498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800143,394649,816650,833577,995222,852157,37207,236150,10558,567612,496448,82446,900612,315749,995412,230828,344587,837963,36862,584830,833987,574732,870656,699208,1034706,290774,517645,282312,171117,88676,170680,368703,265290,369983,187840,382655,152355,879627,337773,674639,76011,255177,53478,220335,141064,984512,1000702,43509,212775,475728,620729,922909,305764,574992,538298,222643,861337,590895,575846,1045151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]