SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801198 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801198 [ RunTime:0.005700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771811,549650,95147,152995,149269,354329,40401,371863,527069,145921,186892,247433,161587,72147,655100,305225,962503,313166,796557,851699,757819,666860,710527,1002533,886341,396108,340962,834342,21547,757441,507577,487392,555393,233055,339542,277204,988041,1016623,680693,930216,261880,293026,164345,685413,484133,29872,393720,279668,433028,568301,749876,1022002,802201,774054,657945,500655,976374,640244,238257,401682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]