SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004459 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004459 [ RunTime:0.005541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446548,701092,1047972,411940,920183,115895,307899,941801,260034,345012,525084,166739,911380,118685,255319,414808,673917,647282,826218,726805,906884,96381,689040,576041,328810,832108,164825,202620,374362,499022,804065,861351,896836,538101,739683,718525,361695,653934,384652,518840,734320,723761,655993,744019,415281,883306,1032552,854623,632551,374254,374535,446960,619420,370050,733857,997007,749254,1035650,584381,1017965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004459 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004459 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]