SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002001 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002001 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880052,61113,483587,1042909,170346,342460,55551,270021,225050,922080,277669,30966,304134,716045,235086,66738,236569,471512,402994,899706,926243,604609,49551,924541,567864,808004,150359,903157,360652,928068,527116,582497,1034555,12565,493591,37955,939424,995966,725180,390589,416171,284643,475032,831601,305736,55299,1036551,774949,175991,664551,840002,676625,735841,21184,454036,838306,436536,660921,545123,508726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]