SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422054 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422054 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439487,128820,294200,311701,1007668,907673,108891,45024,465512,166702,792138,1014848,445285,423864,248176,44220,453036,894814,1035320,518181,138694,1043466,547124,120017,695294,274665,995811,902272,686359,846057,29792,138391,523291,383993,1002214,230969,219376,32510,655477,1038097,494541,257630,271370,239861,467210,285659,563956,48259,814269,248533,435469,568583,811987,182920,90765,506130,743748,684187,605465,800549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]