SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001644s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435343 LIMIT 1 [ RunTime:0.000913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435343 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748250,243181,508815,795157,506184,201,775879,484053,636547,810416,72511,616703,604642,495656,825579,921527,346710,725062,353680,261752,91079,412860,87565,170532,257034,354703,607727,465630,81683,278589,148208,157496,570695,476541,426543,414074,909689,491915,821864,684378,263547,718217,812771,915835,64635,125780,103181,248807,210551,581045,949950,631683,946898,23832,684465,565856,7105,990967,690058,727626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001644s ]