SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029701 LIMIT 1 [ RunTime:0.001098s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029701 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838945,481075,783037,743000,593461,25961,170551,485224,236488,445448,949677,1047985,21176,268420,737687,1016855,420745,355520,853329,387369,363799,944406,480368,869905,838767,776447,743176,46151,1007813,900151,334739,934984,905033,770808,494656,734523,352803,740272,82070,431514,997910,646275,266915,506241,886659,904946,977994,646748,82437,81536,47668,658087,862238,362146,684378,1035396,351033,580819,606717,7572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001997s ]