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` = 771978 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 771978 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739189,427035,912029,486968,805772,783611,47955,1007747,15184,662802,130954,844473,452953,814204,122308,67883,291128,271848,87495,241466,1012818,137627,112265,429159,534992,882257,871187,357357,595774,938579,752770,1024514,49714,130532,386675,41351,130672,1010721,782418,35393,1013361,245862,1036681,371970,408470,770348,13383,737100,333942,134285,24097,22161,226072,993347,802528,196566,944060,192428,623452,916899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 771978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 771978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]