SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480831 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480831 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811850,583838,126106,996188,857385,47628,391782,873734,197724,422079,913140,228751,867867,666593,937907,734814,582625,1005749,920016,995885,493136,176090,413316,261091,116801,821372,29469,557096,83486,335870,799518,54407,696161,940770,50268,781266,941553,62085,614359,700650,294605,1028744,195034,1038653,614518,490557,764656,40300,297544,284017,114853,115693,489015,359249,472286,722769,814322,40961,392719,1032102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002385s ]