SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518763 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518763 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99123,668750,847594,104388,912571,214804,405749,160002,233174,431623,179915,733668,177583,285967,389493,375272,532198,574757,634047,527008,788887,912980,20494,180934,289115,766374,449562,802052,4356,552659,353116,896344,1004505,763937,728502,93185,519543,1023122,50626,37170,564109,462219,737352,514452,703324,61131,948195,72152,212887,665127,658551,197064,168415,22652,610530,676993,81507,790518,44665,503727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]